Overview

Dataset statistics

Number of variables26
Number of observations292
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory72.0 KiB
Average record size in memory252.4 B

Variable types

NUM16
BOOL8
CAT1
DATE1

Reproduction

Analysis started2020-05-05 17:47:21.128876
Analysis finished2020-05-05 17:47:55.288515
Versionpandas-profiling v2.5.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml
udsventa has 57 (19.5%) zeros Zeros
udsprevisionempresa has 82 (28.1%) zeros Zeros
weekday has 41 (14.0%) zeros Zeros
sin_weekday has 41 (14.0%) zeros Zeros
roll4wd_udsventa has 50 (17.1%) zeros Zeros
roll4wd_udsstock has 16 (5.5%) zeros Zeros
udsprevisionempresa_shifted-1 has 83 (28.4%) zeros Zeros
udsprevisionempresa_shifted-2 has 84 (28.8%) zeros Zeros
udsstock_shifted7 has 7 (2.4%) zeros Zeros
roll4wd_udsstock_shifted1 has 17 (5.8%) zeros Zeros
roll4wd_udsstock_shifted7 has 23 (7.9%) zeros Zeros
udsventa_shifted1 has 57 (19.5%) zeros Zeros

Variables

fecha
Date

UNIFORM
UNIQUE
Distinct count292
Unique (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
Minimum2019-06-05 00:00:00
Maximum2020-03-22 00:00:00
Histogram

producto
Categorical

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
48
292
ValueCountFrequency (%) 
48 292 100.0%
 

Length

Max length2
Mean length2
Min length2
ValueCountFrequency (%) 
Decimal_Number 2 100.0%
 
ValueCountFrequency (%) 
Common 2 100.0%
 
ValueCountFrequency (%) 
ASCII 2 100.0%
 

udsstock
Real number (ℝ≥0)

Distinct count109
Unique (%)37.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean913.4504802532862
Minimum48.0
Maximum2316.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum48
5-th percentile421.5
Q1684.6923077
median882
Q31112.935484
95-th percentile1467.5
Maximum2316
Range2268
Interquartile range (IQR)428.2431762

Descriptive statistics

Standard deviation346.2111125
Coefficient of variation (CV)0.3790146483
Kurtosis1.876327376
Mean913.4504803
Median Absolute Deviation (MAD)265.5784802
Skewness0.9025397837
Sum266727.5402
Variance119862.1344
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 48. 401.5 676.34615385 686.34615385 782.43548387 799. 1155.28571429 1160.28571429 1487.5 2316. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
684.6923077 27 9.2%
 
1157.571429 13 4.5%
 
789.8709677 13 4.5%
 
929 12 4.1%
 
1112.935484 11 3.8%
 
968.5806452 10 3.4%
 
697 6 2.1%
 
416 6 2.1%
 
794 6 2.1%
 
513 5 1.7%
 
Other values (99) 183 62.7%
 
ValueCountFrequency (%) 
48 1 0.3%
 
82 1 0.3%
 
290 1 0.3%
 
300 2 0.7%
 
349 1 0.3%
 
ValueCountFrequency (%) 
2316 1 0.3%
 
2190 1 0.3%
 
2132 1 0.3%
 
1996 2 0.7%
 
1918 2 0.7%
 

udsventa
Real number (ℝ≥0)

ZEROS
Distinct count102
Unique (%)34.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean486.458904109589
Minimum0.0
Maximum1719.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1285.25
median523
Q3687.75
95-th percentile888.15
Maximum1719
Range1719
Interquartile range (IQR)402.5

Descriptive statistics

Standard deviation326.1246705
Coefficient of variation (CV)0.6704053883
Kurtosis0.9593022164
Mean486.4589041
Median Absolute Deviation (MAD)256.7473729
Skewness0.3492799132
Sum142046
Variance106357.3007
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 36.5 224.5 888.5 963. 1719. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
560 7 2.4%
 
435 6 2.1%
 
494 6 2.1%
 
376 5 1.7%
 
678 5 1.7%
 
642 5 1.7%
 
442 5 1.7%
 
649 5 1.7%
 
605 5 1.7%
 
Other values (92) 186 63.7%
 
ValueCountFrequency (%) 
0 57 19.5%
 
73 1 0.3%
 
154 1 0.3%
 
199 1 0.3%
 
221 1 0.3%
 
ValueCountFrequency (%) 
1719 1 0.3%
 
1690 1 0.3%
 
1586 1 0.3%
 
1542 2 0.7%
 
1084 1 0.3%
 

udsprevisionempresa
Real number (ℝ≥0)

ZEROS
Distinct count198
Unique (%)67.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2203.890410958904
Minimum0.0
Maximum15296.0
Zeros82
Zeros (%)28.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1682
Q33499.75
95-th percentile6405.4
Maximum15296
Range15296
Interquartile range (IQR)3499.75

Descriptive statistics

Standard deviation2371.920261
Coefficient of variation (CV)1.07624238
Kurtosis4.333880491
Mean2203.890411
Median Absolute Deviation (MAD)1836.812254
Skewness1.628637139
Sum643536
Variance5626005.727
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 4562.5 7149.5 15296. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 82 28.1%
 
4535 3 1.0%
 
2833 2 0.7%
 
97 2 0.7%
 
3719 2 0.7%
 
227 2 0.7%
 
2095 2 0.7%
 
3306 2 0.7%
 
3511 2 0.7%
 
5180 2 0.7%
 
Other values (188) 191 65.4%
 
ValueCountFrequency (%) 
0 82 28.1%
 
51 1 0.3%
 
95 1 0.3%
 
97 2 0.7%
 
162 1 0.3%
 
ValueCountFrequency (%) 
15296 1 0.3%
 
12505 1 0.3%
 
11678 1 0.3%
 
9470 1 0.3%
 
8879 1 0.3%
 

promo
Boolean

CONSTANT
REJECTED
Distinct count1
Unique (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
292
ValueCountFrequency (%) 
0 292 100.0%
 

festivo
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
284
1
 
8
ValueCountFrequency (%) 
0 284 97.3%
 
1 8 2.7%
 

weekday
Real number (ℝ≥0)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.017123287671233
Minimum0
Maximum6
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q11
median3
Q35
95-th percentile6
Maximum6
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.999067122
Coefficient of variation (CV)0.662573893
Kurtosis-1.24431598
Mean3.017123288
Median Absolute Deviation (MAD)1.711249765
Skewness-0.01071552041
Sum881
Variance3.996269359
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 5.5 6. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 
1 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
0 41 14.0%
 
1 41 14.0%
 
2 42 14.4%
 
3 42 14.4%
 
4 42 14.4%
 
ValueCountFrequency (%) 
6 42 14.4%
 
5 42 14.4%
 
4 42 14.4%
 
3 42 14.4%
 
2 42 14.4%
 

working_day
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
True
242
False
50
ValueCountFrequency (%) 
True 242 82.9%
 
False 50 17.1%
 

sin_weekday
Real number (ℝ)

ZEROS
Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.002677505076945293
Minimum-0.9749279121818236
Maximum0.9749279121818236
Zeros41
Zeros (%)14.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9749279122
5-th percentile-0.9749279122
Q1-0.7818314825
median0
Q30.7818314825
95-th percentile0.9749279122
Maximum0.9749279122
Range1.949855824
Interquartile range (IQR)1.563662965

Descriptive statistics

Standard deviation0.7092579884
Coefficient of variation (CV)-264.895105
Kurtosis-1.507989269
Mean-0.002677505077
Median Absolute Deviation (MAD)0.6278742875
Skewness0.006768729133
Sum-0.7818314825
Variance0.5030468941
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.97492791 -0.8783797 0.8783797 0.97492791], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.4338837391 42 14.4%
 
0.4338837391 42 14.4%
 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0 41 14.0%
 
ValueCountFrequency (%) 
-0.9749279122 42 14.4%
 
-0.7818314825 42 14.4%
 
-0.4338837391 42 14.4%
 
0 41 14.0%
 
0.4338837391 42 14.4%
 
ValueCountFrequency (%) 
0.9749279122 42 14.4%
 
0.7818314825 41 14.0%
 
0.4338837391 42 14.4%
 
0 41 14.0%
 
-0.4338837391 42 14.4%
 

cos_weekday
Real number (ℝ)

Distinct count7
Unique (%)2.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean-0.005559896581708024
Minimum-0.9009688679024191
Maximum1.0
Zeros0
Zeros (%)0.0%
Memory size2.4 KiB

Quantile statistics

Minimum-0.9009688679
5-th percentile-0.9009688679
Q1-0.9009688679
median-0.222520934
Q30.6234898019
95-th percentile1
Maximum1
Range1.900968868
Interquartile range (IQR)1.52445867

Descriptive statistics

Standard deviation0.7073551581
Coefficient of variation (CV)-127.2245172
Kurtosis-1.502452694
Mean-0.005559896582
Median Absolute Deviation (MAD)0.6399937036
Skewness0.01159750905
Sum-1.623489802
Variance0.5003513197
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-0.90096887 -0.90096887 1. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
0.6234898019 42 14.4%
 
0.6234898019 41 14.0%
 
1 41 14.0%
 
ValueCountFrequency (%) 
-0.9009688679 42 14.4%
 
-0.9009688679 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 
0.6234898019 42 14.4%
 
ValueCountFrequency (%) 
1 41 14.0%
 
0.6234898019 41 14.0%
 
0.6234898019 42 14.4%
 
-0.222520934 42 14.4%
 
-0.222520934 42 14.4%
 

is_august
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
261
1
 
31
ValueCountFrequency (%) 
0 261 89.4%
 
1 31 10.6%
 

spring
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
291
1
 
1
ValueCountFrequency (%) 
0 291 99.7%
 
1 1 0.3%
 

summer
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
184
1
108
ValueCountFrequency (%) 
0 184 63.0%
 
1 108 37.0%
 

autumn
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
202
1
90
ValueCountFrequency (%) 
0 202 69.2%
 
1 90 30.8%
 

winter
Boolean

Distinct count2
Unique (%)0.7%
Missing0
Missing (%)0.0%
Memory size2.4 KiB
0
200
1
92
ValueCountFrequency (%) 
0 200 68.5%
 
1 92 31.5%
 

roll4wd_udsventa
Real number (ℝ≥0)

ZEROS
Distinct count238
Unique (%)81.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean486.9030944227006
Minimum0.0
Maximum1055.625
Zeros50
Zeros (%)17.1%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1375.4196429
median531.6875
Q3673.8125
95-th percentile841.41875
Maximum1055.625
Range1055.625
Interquartile range (IQR)298.3928571

Descriptive statistics

Standard deviation266.248991
Coefficient of variation (CV)0.5468213162
Kurtosis-0.4556500722
Mean486.9030944
Median Absolute Deviation (MAD)211.2813741
Skewness-0.6333961159
Sum142175.7036
Variance70888.5252
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 133.07142857 266.71428571 394.25 745.0625 880.75 1055.625 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 50 17.1%
 
829 2 0.7%
 
477.375 2 0.7%
 
421.875 2 0.7%
 
554.75 2 0.7%
 
605.5 2 0.7%
 
899.8571429 1 0.3%
 
516.125 1 0.3%
 
743.375 1 0.3%
 
709 1 0.3%
 
Other values (228) 228 78.1%
 
ValueCountFrequency (%) 
0 50 17.1%
 
266.1428571 1 0.3%
 
267.2857143 1 0.3%
 
274.5 1 0.3%
 
280.875 1 0.3%
 
ValueCountFrequency (%) 
1055.625 1 0.3%
 
1036.75 1 0.3%
 
941.5 1 0.3%
 
903.875 1 0.3%
 
899.8571429 1 0.3%
 

roll4wd_udsstock
Real number (ℝ≥0)

ZEROS
Distinct count239
Unique (%)81.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean886.6786570450098
Minimum0.0
Maximum2132.0
Zeros16
Zeros (%)5.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1711.15625
median883.375
Q31109.955357
95-th percentile1398.957143
Maximum2132
Range2132
Interquartile range (IQR)398.7991071

Descriptive statistics

Standard deviation352.0939277
Coefficient of variation (CV)0.3970930448
Kurtosis1.258886948
Mean886.678657
Median Absolute Deviation (MAD)256.8636876
Skewness-0.2141847036
Sum258910.1679
Variance123970.1339
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 174.25 445.66964286 689.8 975.875 1377.39285714 2132. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 16 5.5%
 
746 6 2.1%
 
523 4 1.4%
 
814 3 1.0%
 
691.6 2 0.7%
 
702.7142857 2 0.7%
 
856.5714286 2 0.7%
 
1139.5 2 0.7%
 
790 2 0.7%
 
940 2 0.7%
 
Other values (229) 251 86.0%
 
ValueCountFrequency (%) 
0 16 5.5%
 
348.5 1 0.3%
 
412.4 1 0.3%
 
432.7142857 1 0.3%
 
458.625 2 0.7%
 
ValueCountFrequency (%) 
2132 1 0.3%
 
1892 1 0.3%
 
1763.4 1 0.3%
 
1726.8 1 0.3%
 
1718.25 1 0.3%
 

udsprevisionempresa_shifted-1
Real number (ℝ≥0)

ZEROS
Distinct count197
Unique (%)67.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2163.8972602739727
Minimum0.0
Maximum15296.0
Zeros83
Zeros (%)28.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1650.5
Q33442.5
95-th percentile6346.4
Maximum15296
Range15296
Interquartile range (IQR)3442.5

Descriptive statistics

Standard deviation2309.251531
Coefficient of variation (CV)1.067172446
Kurtosis4.284349069
Mean2163.89726
Median Absolute Deviation (MAD)1805.613952
Skewness1.57523176
Sum631858
Variance5332642.635
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 4562.5 7149.5 15296. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 83 28.4%
 
4535 3 1.0%
 
2833 2 0.7%
 
97 2 0.7%
 
3719 2 0.7%
 
227 2 0.7%
 
2095 2 0.7%
 
3306 2 0.7%
 
3511 2 0.7%
 
5180 2 0.7%
 
Other values (187) 190 65.1%
 
ValueCountFrequency (%) 
0 83 28.4%
 
51 1 0.3%
 
95 1 0.3%
 
97 2 0.7%
 
162 1 0.3%
 
ValueCountFrequency (%) 
15296 1 0.3%
 
12505 1 0.3%
 
9470 1 0.3%
 
8879 1 0.3%
 
8336 1 0.3%
 

udsprevisionempresa_shifted-2
Real number (ℝ≥0)

ZEROS
Distinct count196
Unique (%)67.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2111.513698630137
Minimum0.0
Maximum12505.0
Zeros84
Zeros (%)28.8%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1639.5
Q33406
95-th percentile6317.15
Maximum12505
Range12505
Interquartile range (IQR)3406

Descriptive statistics

Standard deviation2180.220422
Coefficient of variation (CV)1.032539085
Kurtosis1.67397402
Mean2111.513699
Median Absolute Deviation (MAD)1759.697363
Skewness1.184872877
Sum616562
Variance4753361.089
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 25.5 4562.5 7149.5 12505. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 84 28.8%
 
4535 3 1.0%
 
97 2 0.7%
 
2095 2 0.7%
 
1518 2 0.7%
 
5180 2 0.7%
 
3719 2 0.7%
 
2355 2 0.7%
 
3306 2 0.7%
 
3511 2 0.7%
 
Other values (186) 189 64.7%
 
ValueCountFrequency (%) 
0 84 28.8%
 
51 1 0.3%
 
95 1 0.3%
 
97 2 0.7%
 
162 1 0.3%
 
ValueCountFrequency (%) 
12505 1 0.3%
 
9470 1 0.3%
 
8879 1 0.3%
 
8336 1 0.3%
 
8088 1 0.3%
 

udsstock_shifted1
Real number (ℝ≥0)

Distinct count109
Unique (%)37.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean912.4573295683547
Minimum0.0
Maximum2316.0
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile421.5
Q1684.6923077
median882
Q31112.935484
95-th percentile1467.5
Maximum2316
Range2316
Interquartile range (IQR)428.2431762

Descriptive statistics

Standard deviation348.414644
Coefficient of variation (CV)0.3818421232
Kurtosis1.892916038
Mean912.4573296
Median Absolute Deviation (MAD)266.5308165
Skewness0.8516058427
Sum266437.5402
Variance121392.7642
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 401.5 676.34615385 686.34615385 782.43548387 799. 1155.28571429 1160.28571429 1487.5 2316. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
684.6923077 27 9.2%
 
789.8709677 13 4.5%
 
1157.571429 13 4.5%
 
929 12 4.1%
 
1112.935484 11 3.8%
 
968.5806452 10 3.4%
 
416 6 2.1%
 
794 6 2.1%
 
697 6 2.1%
 
552 5 1.7%
 
Other values (99) 183 62.7%
 
ValueCountFrequency (%) 
0 1 0.3%
 
48 1 0.3%
 
82 1 0.3%
 
300 2 0.7%
 
349 1 0.3%
 
ValueCountFrequency (%) 
2316 1 0.3%
 
2190 1 0.3%
 
2132 1 0.3%
 
1996 2 0.7%
 
1918 2 0.7%
 

udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count105
Unique (%)36.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean899.0478662963197
Minimum0.0
Maximum2316.0
Zeros7
Zeros (%)2.4%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile416
Q1684.6923077
median882
Q31112.935484
95-th percentile1463
Maximum2316
Range2316
Interquartile range (IQR)428.2431762

Descriptive statistics

Standard deviation364.7047617
Coefficient of variation (CV)0.4056566679
Kurtosis1.819479108
Mean899.0478663
Median Absolute Deviation (MAD)275.5532616
Skewness0.5785868442
Sum262521.977
Variance133009.5632
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 41. 401.5 676.34615385 686.34615385 ... 799. 1155.28571429 1160.28571429 1482.5 2316. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
684.6923077 26 8.9%
 
1157.571429 13 4.5%
 
789.8709677 12 4.1%
 
929 12 4.1%
 
1112.935484 11 3.8%
 
968.5806452 10 3.4%
 
0 7 2.4%
 
697 6 2.1%
 
416 6 2.1%
 
794 6 2.1%
 
Other values (95) 183 62.7%
 
ValueCountFrequency (%) 
0 7 2.4%
 
82 1 0.3%
 
300 2 0.7%
 
358 1 0.3%
 
368 1 0.3%
 
ValueCountFrequency (%) 
2316 1 0.3%
 
2190 1 0.3%
 
2132 1 0.3%
 
1996 2 0.7%
 
1918 2 0.7%
 

roll4wd_udsstock_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count238
Unique (%)81.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean884.5724926614481
Minimum0.0
Maximum2132.0
Zeros17
Zeros (%)5.8%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1711.15625
median883.375
Q31109.955357
95-th percentile1398.957143
Maximum2132
Range2132
Interquartile range (IQR)398.7991071

Descriptive statistics

Standard deviation355.5471241
Coefficient of variation (CV)0.4019423248
Kurtosis1.223089953
Mean884.5724927
Median Absolute Deviation (MAD)258.9410004
Skewness-0.2422327309
Sum258295.1679
Variance126413.7575
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 174.25 445.66964286 689.8 975.875 1377.39285714 2132. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 17 5.8%
 
746 6 2.1%
 
523 4 1.4%
 
814 3 1.0%
 
908.125 2 0.7%
 
575.5714286 2 0.7%
 
840.6 2 0.7%
 
513 2 0.7%
 
1133 2 0.7%
 
1085 2 0.7%
 
Other values (228) 250 85.6%
 
ValueCountFrequency (%) 
0 17 5.8%
 
348.5 1 0.3%
 
412.4 1 0.3%
 
432.7142857 1 0.3%
 
458.625 2 0.7%
 
ValueCountFrequency (%) 
2132 1 0.3%
 
1892 1 0.3%
 
1763.4 1 0.3%
 
1726.8 1 0.3%
 
1718.25 1 0.3%
 

roll4wd_udsstock_shifted7
Real number (ℝ≥0)

ZEROS
Distinct count233
Unique (%)79.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean865.8993272994128
Minimum0.0
Maximum2132.0
Zeros23
Zeros (%)7.9%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1701.2857143
median878.7
Q31104.857143
95-th percentile1376.303571
Maximum2132
Range2132
Interquartile range (IQR)403.5714286

Descriptive statistics

Standard deviation373.8624318
Coefficient of variation (CV)0.4317620075
Kurtosis0.991180717
Mean865.8993273
Median Absolute Deviation (MAD)272.0044278
Skewness-0.3348204769
Sum252842.6036
Variance139773.1179
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 206.2 445.66964286 689.8 975.875 1377.39285714 2132. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 23 7.9%
 
746 6 2.1%
 
523 4 1.4%
 
814 3 1.0%
 
702.7142857 2 0.7%
 
856.5714286 2 0.7%
 
1139.5 2 0.7%
 
790 2 0.7%
 
940 2 0.7%
 
499.875 2 0.7%
 
Other values (223) 244 83.6%
 
ValueCountFrequency (%) 
0 23 7.9%
 
412.4 1 0.3%
 
432.7142857 1 0.3%
 
458.625 2 0.7%
 
470.25 1 0.3%
 
ValueCountFrequency (%) 
2132 1 0.3%
 
1892 1 0.3%
 
1763.4 1 0.3%
 
1726.8 1 0.3%
 
1718.25 1 0.3%
 

udsventa_shifted1
Real number (ℝ≥0)

ZEROS
Distinct count102
Unique (%)34.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean486.458904109589
Minimum0.0
Maximum1719.0
Zeros57
Zeros (%)19.5%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile0
Q1285.25
median523
Q3687.75
95-th percentile888.15
Maximum1719
Range1719
Interquartile range (IQR)402.5

Descriptive statistics

Standard deviation326.1246705
Coefficient of variation (CV)0.6704053883
Kurtosis0.9593022164
Mean486.4589041
Median Absolute Deviation (MAD)256.7473729
Skewness0.3492799132
Sum142046
Variance106357.3007
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 36.5 224.5 888.5 963. 1719. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 57 19.5%
 
560 7 2.4%
 
494 6 2.1%
 
435 6 2.1%
 
649 5 1.7%
 
678 5 1.7%
 
642 5 1.7%
 
442 5 1.7%
 
605 5 1.7%
 
568 5 1.7%
 
Other values (92) 186 63.7%
 
ValueCountFrequency (%) 
0 57 19.5%
 
73 1 0.3%
 
154 1 0.3%
 
199 1 0.3%
 
221 1 0.3%
 
ValueCountFrequency (%) 
1719 1 0.3%
 
1690 1 0.3%
 
1586 1 0.3%
 
1542 2 0.7%
 
1084 1 0.3%
 

roll4_udstock_shifted1
Real number (ℝ≥0)

Distinct count274
Unique (%)93.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean908.181946464384
Minimum0.0
Maximum1971.75
Zeros1
Zeros (%)0.3%
Memory size2.4 KiB

Quantile statistics

Minimum0
5-th percentile536.34375
Q1756.9495303
median892.5604396
Q31027.329637
95-th percentile1345.471371
Maximum1971.75
Range1971.75
Interquartile range (IQR)270.3801068

Descriptive statistics

Standard deviation243.4121081
Coefficient of variation (CV)0.2680213024
Kurtosis2.523231331
Mean908.1819465
Median Absolute Deviation (MAD)180.5578784
Skewness0.5239854693
Sum265189.1284
Variance59249.45438
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 387.54003456 639.76101117 1006.92057338 1007.33387983 1100.125 1499.85771889 1971.75 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
892.5604396 5 1.7%
 
1007.16776 5 1.7%
 
756.9495303 3 1.0%
 
1031.494816 3 1.0%
 
759.6203474 2 0.7%
 
647.625 2 0.7%
 
847.625 2 0.7%
 
995.4274194 2 0.7%
 
884.1228288 2 0.7%
 
851.125 2 0.7%
 
Other values (264) 264 90.4%
 
ValueCountFrequency (%) 
0 1 0.3%
 
123.5 1 0.3%
 
370.7050691 1 0.3%
 
404.375 1 0.3%
 
424.75 1 0.3%
 
ValueCountFrequency (%) 
1971.75 1 0.3%
 
1916.125 1 0.3%
 
1620.5 1 0.3%
 
1506.196429 1 0.3%
 
1493.519009 1 0.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Missing values

Sample

First rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
02019-06-0548494.000000664.011678.00.00.02True0.974928-0.22252100100664.00494.015296.012505.00.0000000.0000000.00.00.00.000000
12019-06-06481112.935484730.015296.00.00.03True0.433884-0.90096900100730.000.012505.02841.0494.0000000.000000494.00.0664.0123.500000
22019-06-0748929.000000575.012505.00.00.04True-0.433884-0.90096900100575.000.02841.00.01112.9354840.0000000.00.0730.0370.705069
32019-06-08481157.571429619.02841.00.00.05True-0.974928-0.22252100100619.000.00.04219.0929.0000000.0000000.00.0575.0718.725806
42019-06-0948684.6923080.00.00.00.06False-0.7818310.623490001000.000.04219.03498.01157.5714290.0000000.00.0619.0972.172235
52019-06-1048684.692308398.04219.00.00.00True0.0000001.00000000100398.000.03498.01594.0684.6923080.0000000.00.00.01007.167760
62019-06-1148882.000000405.03498.00.00.01True0.7818310.62349000100405.00882.01594.02599.0684.6923080.0000000.00.0398.0892.560440
72019-06-12481366.000000560.01594.00.00.02True0.974928-0.22252100100638.00712.02599.03914.0882.000000494.000000882.0494.0405.0768.465659
82019-06-13481560.000000797.02599.00.00.03True0.433884-0.90096900100746.751560.03914.01284.01366.0000001112.935484712.00.0560.0843.846154
92019-06-1448843.000000826.03914.00.00.04True-0.433884-0.90096900100637.75843.01284.00.01560.000000929.0000001560.00.0797.01123.586538

Last rows

fechaproductoudsstockudsventaudsprevisionempresapromofestivoweekdayworking_daysin_weekdaycos_weekdayis_augustspringsummerautumnwinterroll4wd_udsventaroll4wd_udsstockudsprevisionempresa_shifted-1udsprevisionempresa_shifted-2udsstock_shifted1udsstock_shifted7roll4wd_udsstock_shifted1roll4wd_udsstock_shifted7udsventa_shifted1roll4_udstock_shifted1
2822020-03-1348929.0000001690.06721.00.00.04True-0.433884-0.90096900001736.875649.0000000.00.01112.935484929.0000001066.000000753.250000339.0973.046216
2832020-03-1448959.0000001542.00.00.00.05True-0.974928-0.22252100001689.2501256.7500000.01476.0929.0000001157.571429649.0000001356.0000001690.01025.068548
2842020-03-1548684.6923080.00.00.00.06False-0.7818310.623490000010.000940.0000001476.01757.0959.000000684.6923081256.750000940.0000001542.01006.673387
2852020-03-1648684.692308309.01476.00.00.00True0.0000001.00000000001468.250879.2500001757.03145.0684.692308684.692308940.000000809.5714290.0932.703474
2862020-03-1748789.8709681719.01757.00.00.01True0.7818310.62349000001543.500926.7142863145.03574.0684.6923081027.000000879.250000888.250000309.0818.096154
2872020-03-1848571.000000605.03145.00.00.02True0.974928-0.22252100001673.7501449.4000003574.03505.0789.870968968.580645926.7142861292.8571431719.0732.128102
2882020-03-1948349.0000001586.03574.00.00.03True0.433884-0.90096900001696.875707.5000003505.00.0571.0000001112.9354841449.4000001066.000000605.0709.922767
2892020-03-204848.000000730.03505.00.00.04True-0.433884-0.900969000011036.750348.5000000.00.0349.000000929.000000707.500000649.0000001586.0639.538151
2902020-03-21481473.0000001542.00.00.00.05True-0.974928-0.222521000011055.6251141.2000000.00.048.000000959.000000348.5000001256.750000730.0449.733871
2912020-03-2248290.0000000.00.00.00.06False-0.7818310.623490010010.000615.0000000.00.01473.000000684.6923081141.200000940.0000001542.0404.375000